UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aBz/1sgYFiO9wBtkJHXc1hOqIjTmfIDKjPSPJ+N7kqQ='
WHERE
key_id = 'd4cda227d03381faa3281549038ec99d70e0d234174b8ae2582a57d2ff35e1bd'
AND (
token = 'aBz/1sgYFiO9wBtkJHXc1hOqIjTmfIDKjPSPJ+N7kqQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)