UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9RLnzn/wtq9qdY3eMXfms5bYTBPaTwVOYoxkmWkDKwE='
WHERE
key_id = 'b71a7b560d2ac2061161bfd25a4c1d1b588d6af4a546bae71312fcdbfa4a57ad'
AND (
token = '9RLnzn/wtq9qdY3eMXfms5bYTBPaTwVOYoxkmWkDKwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)