UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NnNw3qGCwHQPXxIcY46Y8DvzbryLE9DLvrOkewnZyxQ='
WHERE
key_id = '95e3aedf040dcceba04834375ccc2b03ef361bb39fe8c257176f7e79d7c359ef'
AND (
token = 'NnNw3qGCwHQPXxIcY46Y8DvzbryLE9DLvrOkewnZyxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)