UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p+MSGVjZ+rAGUZTU76W2A1mc1opMZhS6VoY3C9tZDgE='
WHERE
key_id = 'a11e475b6dd163b58e9e29a76bd459a0088d3b68cadf78b87addf1d4eb196af1'
AND (
token = 'p+MSGVjZ+rAGUZTU76W2A1mc1opMZhS6VoY3C9tZDgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)