UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd6tGI3jD4/q0A3RY3W2MunBKog1SKjK0JvfjivHI+jI='
WHERE
key_id = 'bcc578a22ac242493aba28e5a3db5bf11efb76cae12dd6024e51cd1e56ea32e1'
AND (
token = 'd6tGI3jD4/q0A3RY3W2MunBKog1SKjK0JvfjivHI+jI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)