UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jpi4gSb45EvhkBlMt5Kc6MS1eqkkA1kEAW54N4Audp8='
WHERE
key_id = 'c6164cbb49845b1b6cfc07df2770a033ab66ecf08f01668f28d0c37ca5d639d4'
AND (
token = 'jpi4gSb45EvhkBlMt5Kc6MS1eqkkA1kEAW54N4Audp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)