UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N7waJyB22FQe3yY4mJ1AL9LETgiESxmVQRP/B6dQff4='
WHERE
key_id = '6a98c5c4d58e582eec66d9a908d8f972d4754b2d4d32f4a4a69307584906d880'
AND (
token = 'N7waJyB22FQe3yY4mJ1AL9LETgiESxmVQRP/B6dQff4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)