UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IPgVT8r7m5zxkCQdwbRy7dsOwUY893RecfaCh+pgQrY='
WHERE
key_id = '6be16e63a9c0c5063181917941c519438ab465575514a1b85027d9d77745fb5b'
AND (
token = 'IPgVT8r7m5zxkCQdwbRy7dsOwUY893RecfaCh+pgQrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)