UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7tVHNnWl7cpkjLWbfW+nndP7S5QDjwlhuG/YZ/AUONU='
WHERE
key_id = '5ef87a476b7b440c375503037959ebd33ba4114b6a67c556e77e94e73544f9df'
AND (
token = '7tVHNnWl7cpkjLWbfW+nndP7S5QDjwlhuG/YZ/AUONU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)