UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'abtK4BJNy9gg+y6DpmNlujzkoeZ7Mx85VRfLL3eFrAk='
WHERE
key_id = 'a82803338ed8df11d36a7f974e76c1d59c8894c8e6d78bd410119175ec90d810'
AND (
token = 'abtK4BJNy9gg+y6DpmNlujzkoeZ7Mx85VRfLL3eFrAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)