UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2cFviesezDawm7Y2k5y8RYAq/aSJJxhZ0CiP8Cas+Ss='
WHERE
key_id = 'b22f2baf9821b573de04cf3ad33c13dccc329d2b74c3632c66befccb155e4120'
AND (
token = '2cFviesezDawm7Y2k5y8RYAq/aSJJxhZ0CiP8Cas+Ss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)