UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zx8f7z6BJKs2zLUDSilvQbJcJ7CrXaqnbEbQKy4GT6U='
WHERE
key_id = 'c9b1fe3d51756c20a24bdb6a31867d217b489641de3dc432222c4a84537545b3'
AND (
token = 'Zx8f7z6BJKs2zLUDSilvQbJcJ7CrXaqnbEbQKy4GT6U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)