UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YqZsL0yLU6qwkXNUAHnq2lWC3DHUerlJURlwsclVVBc='
WHERE
key_id = '3e88bf245e43e1fd03ca92d4614cbf1a77af5fce6f3622b9406af0d11fac79d9'
AND (
token = 'YqZsL0yLU6qwkXNUAHnq2lWC3DHUerlJURlwsclVVBc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)