UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XIDwg4wSMgVinmc9U0lsgCux2LklyNHGHI1LbMEhCo4='
WHERE
key_id = '71177fbb04e0e868c15027581bff130aa69f5a9752fb82c8d7adde2d26b011e7'
AND (
token = 'XIDwg4wSMgVinmc9U0lsgCux2LklyNHGHI1LbMEhCo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)