UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8D4EIS4pEc+/B/VbMYeXGdveOGldxaiPitmlHQTKqLo='
WHERE
key_id = '4c9ebbb270416a4e7f41ee5e66dd3d3659c3451442c75c1fd0e1377119443b3e'
AND (
token = '8D4EIS4pEc+/B/VbMYeXGdveOGldxaiPitmlHQTKqLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)