UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CiLoCUqVHcHf6PfmdP/fMrhkUv7XA5XCWSTHj5j6AWA='
WHERE
key_id = 'b287c308ca1f34ebf79c00b53a41dc74592884cd8a721b95786755dda8ab15bc'
AND (
token = 'CiLoCUqVHcHf6PfmdP/fMrhkUv7XA5XCWSTHj5j6AWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)