UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9sCEkYzwyhJd/HIISG0IZ98BLkP8K/xfUvGQkJLA68='
WHERE
key_id = '9218426827112dcf68f493bd38553822f9ab34290921104df6bb6c9cb2ff1790'
AND (
token = 'N9sCEkYzwyhJd/HIISG0IZ98BLkP8K/xfUvGQkJLA68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)