UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ROHtjZCZJQb1PvjdrYqLVk8vTsTs5cvCH8NSNQvZcfU='
WHERE
key_id = 'c880e6cd6dc2f32eba41e2d81f8515888c3fd35d0eee2d56a11b84a2c0ce66cd'
AND (
token = 'ROHtjZCZJQb1PvjdrYqLVk8vTsTs5cvCH8NSNQvZcfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)