UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/1kIYycIcJ7VjV2L4AjxRLvpAHZB7tV0WCoTUl2FwcA='
WHERE
key_id = '16dfb37f6957f3f8bd41817c3a9b246d2633a853966ba89c6b5d54bad2bb1c02'
AND (
token = '/1kIYycIcJ7VjV2L4AjxRLvpAHZB7tV0WCoTUl2FwcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)