UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hHZUI6ao8ugLed8SIa+BAGo5xU+nVmZE7rq2AlsACNY='
WHERE
key_id = 'c6fd8ac5c4e324fd214a344fa92910d0b2d159d9db4a0e569ecba6a026237ec9'
AND (
token = 'hHZUI6ao8ugLed8SIa+BAGo5xU+nVmZE7rq2AlsACNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)