UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HrWGjdQ7W808BjFMC1XsDHdf99wkiOnw8eTF2iBFHWc='
WHERE
key_id = '647331d3742668d41ec13716d489cd8fc2c158d2e18499191bf2bb55926facc6'
AND (
token = 'HrWGjdQ7W808BjFMC1XsDHdf99wkiOnw8eTF2iBFHWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)