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