UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9V4HRlBI1g7dLWtQoOMb9mwwnk82ip7NqLufH2nX/LU='
WHERE
key_id = '7b8a84227de4c018d22ed014210669976c0ca6c90f47cc8cd2a0c7657777738a'
AND (
token = '9V4HRlBI1g7dLWtQoOMb9mwwnk82ip7NqLufH2nX/LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)