UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HEf68Uea2H0coH+JK+kY8UPnZX6JOCY586Dqrj3y0nU='
WHERE
key_id = 'c5a9def1b2a52407a3e1ac77403bf6dc64fcb2c24957ee5977d234a9d3b9a18c'
AND (
token = 'HEf68Uea2H0coH+JK+kY8UPnZX6JOCY586Dqrj3y0nU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)