UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mBy4UL6lhS51UfRp1pvX/+IUtJ7VrLc7CaESaGnkkaw='
WHERE
key_id = 'aaed1341858062e2515e867bb5f479b88fe542b4d059819b10490e773c30833c'
AND (
token = 'mBy4UL6lhS51UfRp1pvX/+IUtJ7VrLc7CaESaGnkkaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)