UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BtjM8zlBizjwvbALfwlhu8djDfCAg6NA9CrOggJokKw='
WHERE
key_id = '74a0d36d36a61f578b906461ddc44e71ae347c2da61cda9aabc8f655c8c47f9a'
AND (
token = 'BtjM8zlBizjwvbALfwlhu8djDfCAg6NA9CrOggJokKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)