UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQZ5U9wdigsaQgRol+tHXpYwd/AE/6g1apYURXuj8x8='
WHERE
key_id = '7e07b283508c2445932402ca3a96951a0f1b68c7442698b0d6995f7f190c75bf'
AND (
token = 'ZQZ5U9wdigsaQgRol+tHXpYwd/AE/6g1apYURXuj8x8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)