UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HFHCzegs5hvxYXICEZmWsYzNDd70x1+kGAK8g60R1Nw='
WHERE
key_id = '9fcac086a7cac56231660b0b9af33e6f4557b7e861134b2c22a71962165b163e'
AND (
token = 'HFHCzegs5hvxYXICEZmWsYzNDd70x1+kGAK8g60R1Nw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)