UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OiAGAy4k2mpf2yXDU9N6ycKKsGD7jnEjxis5m9Dlws8='
WHERE
key_id = '7bbccc7f78568fabdf5630fbe35695261cb2f0e7d946eff68650cc3bb0cf3bbd'
AND (
token = 'OiAGAy4k2mpf2yXDU9N6ycKKsGD7jnEjxis5m9Dlws8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)