UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O9Gmvrx1mTAbVSCgPjmXxdxWeGjD+mNZoQCTmFj4I+0='
WHERE
key_id = 'a1c6e2e6a666c1e14511766c0a833f0fe42a3186a5ecc403c18e496341374f84'
AND (
token = 'O9Gmvrx1mTAbVSCgPjmXxdxWeGjD+mNZoQCTmFj4I+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)