UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '46vaAGqRN9RCeRxiGU3clg8Fl85njep6gpq0BtYU3xs='
WHERE
key_id = 'c7b79b6557766a480abffdb0842af58a77628e243a24ed8d954f4cbb231718e9'
AND (
token = '46vaAGqRN9RCeRxiGU3clg8Fl85njep6gpq0BtYU3xs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)