UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XLdxsZ9nddFTW26wftKmzSfll23CVlODy9RG2bZEB8='
WHERE
key_id = 'f2ac02fbb33faaa509385f80a1896fa09dd4d7b518cb14ba11cefbbe8c1f1552'
AND (
token = '6XLdxsZ9nddFTW26wftKmzSfll23CVlODy9RG2bZEB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)