UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mLV5LHE+RD+VIZpifLPbcW68Gm0LTAUiisot4Hp08Jo='
WHERE
key_id = 'e68db36da22ffd68bd099d9d11e74ef914f9b94dd650e23b415794b89b54d03a'
AND (
token = 'mLV5LHE+RD+VIZpifLPbcW68Gm0LTAUiisot4Hp08Jo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)