UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+EmwJ7O9pReVrYS+p2GsYLblHWH/Vqh56rpCEeuDwc8='
WHERE
key_id = '0ce0513e9a4e932e6399233d8df98e4b1d4e03a584ab5c7d64c03cf50196d154'
AND (
token = '+EmwJ7O9pReVrYS+p2GsYLblHWH/Vqh56rpCEeuDwc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)