UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WG5SpCWdhk6yJ9qjbRp0pLC5F344xL+qKKktkUCNKCE='
WHERE
key_id = '0517b8ee856593a7172d0e40500a9c990b05d3f54d7b15fc348bc1db87e1c968'
AND (
token = 'WG5SpCWdhk6yJ9qjbRp0pLC5F344xL+qKKktkUCNKCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)