UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K/q16LkS14eBB1Q23OszZX1eggSm07c49qaAS96e4xc='
WHERE
key_id = '256e3971e6f4415054cbd65c0bea94e80dbc2852fbc27177569e8f1e684d6a8c'
AND (
token = 'K/q16LkS14eBB1Q23OszZX1eggSm07c49qaAS96e4xc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)